Rapport EDA

Dataset statistics

Number of variables	22
Number of observations	5010
Missing cells	991
Missing cells (%)	0.9%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	5.2 MiB
Average record size in memory	1.1 KiB

Variable types

DateTime	1
Categorical	10
Text	4
Numeric	7

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`NetAmount` is highly overall correlated with `QuantitySold` and 1 other fields	High correlation
`ProductCategory` is highly overall correlated with `ProductName` and 2 other fields	High correlation
`ProductName` is highly overall correlated with `ProductCategory` and 2 other fields	High correlation
`ProductPrice` is highly overall correlated with `ProductCategory` and 2 other fields	High correlation
`ProductSubCategory` is highly overall correlated with `ProductCategory` and 2 other fields	High correlation
`QuantitySold` is highly overall correlated with `NetAmount` and 1 other fields	High correlation
`StockOnHand` is highly overall correlated with `StockReceived`	High correlation
`StockReceived` is highly overall correlated with `StockOnHand` and 1 other fields	High correlation
`StockSold` is highly overall correlated with `StockReceived`	High correlation
`SupplierContact` is highly overall correlated with `SupplierLocation` and 1 other fields	High correlation
`SupplierLocation` is highly overall correlated with `SupplierContact` and 1 other fields	High correlation
`SupplierName` is highly overall correlated with `SupplierContact` and 1 other fields	High correlation
`TotalAmount` is highly overall correlated with `NetAmount` and 1 other fields	High correlation
`CustomerEmail` has 507 (10.1%) missing values	Missing
`SupplierContact` has 484 (9.7%) missing values	Missing

Reproduction

Analysis started	2024-12-20 14:45:51.191513
Analysis finished	2024-12-20 14:45:56.866254
Duration	5.67 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

Date
Date

Distinct	729
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Memory size	39.3 KiB

Minimum	2021-09-28 00:00:00
Maximum	2023-09-28 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

ProductName
Categorical

High correlation

Distinct	21
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	314.2 KiB

NonExistentProduct	462
Anthony	251
Robert	246
Wanda	246
Angela	244
Other values (16)	3561

Length

Max length	18
Median length	8
Mean length	7.2007984
Min length	3

Characters and Unicode

Total characters	36076
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nathaniel
2nd row	NonExistentProduct
3rd row	Angela
4th row	Amy
5th row	Nathaniel

Common Values

Value	Count	Frequency (%)
NonExistentProduct	462	9.2%
Anthony	251	5.0%
Robert	246	4.9%
Wanda	246	4.9%
Angela	244	4.9%
Fred	240	4.8%
Shannon	239	4.8%
Michael	236	4.7%
Shawn	235	4.7%
Marvin	233	4.7%
Other values (11)	2378	47.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nonexistentproduct	462	9.2%
anthony	251	5.0%
robert	246	4.9%
wanda	246	4.9%
angela	244	4.9%
fred	240	4.8%
shannon	239	4.8%
michael	236	4.7%
shawn	235	4.7%
marvin	233	4.7%
Other values (11)	2378	47.5%

Most occurring characters

Value	Count	Frequency (%)
a	4011	11.1%
n	4000	11.1%
t	3417	9.5%
e	2706	7.5%
i	2687	7.4%
h	1843	5.1%
o	1660	4.6%
r	1618	4.5%
l	1122	3.1%
m	1057	2.9%
Other values (24)	11955	33.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	36076	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	4011	11.1%
n	4000	11.1%
t	3417	9.5%
e	2706	7.5%
i	2687	7.4%
h	1843	5.1%
o	1660	4.6%
r	1618	4.5%
l	1122	3.1%
m	1057	2.9%
Other values (24)	11955	33.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	36076	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	4011	11.1%
n	4000	11.1%
t	3417	9.5%
e	2706	7.5%
i	2687	7.4%
h	1843	5.1%
o	1660	4.6%
r	1618	4.5%
l	1122	3.1%
m	1057	2.9%
Other values (24)	11955	33.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	36076	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	4011	11.1%
n	4000	11.1%
t	3417	9.5%
e	2706	7.5%
i	2687	7.4%
h	1843	5.1%
o	1660	4.6%
r	1618	4.5%
l	1122	3.1%
m	1057	2.9%
Other values (24)	11955	33.1%

ProductCategory
Categorical

High correlation

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	323.4 KiB

Electronics	1575
Books	1098
Toys	725
Home & Garden	648
InvalidCategory	516

Length

Max length	15
Median length	13
Mean length	9.0744511
Min length	4

Characters and Unicode

Total characters	45463
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Electronics
2nd row	Electronics
3rd row	InvalidCategory
4th row	Home & Garden
5th row	Electronics

Common Values

Value	Count	Frequency (%)
Electronics	1575	31.4%
Books	1098	21.9%
Toys	725	14.5%
Home & Garden	648	12.9%
InvalidCategory	516	10.3%
Clothing	448	8.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
electronics	1575	25.0%
books	1098	17.4%
toys	725	11.5%
home	648	10.3%
	648	10.3%
garden	648	10.3%
invalidcategory	516	8.2%
clothing	448	7.1%

Most occurring characters

Value	Count	Frequency (%)
o	6108	13.4%
s	3398	7.5%
e	3387	7.5%
n	3187	7.0%
c	3150	6.9%
r	2739	6.0%
t	2539	5.6%
l	2539	5.6%
i	2539	5.6%
a	1680	3.7%
Other values (16)	14197	31.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	45463	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	6108	13.4%
s	3398	7.5%
e	3387	7.5%
n	3187	7.0%
c	3150	6.9%
r	2739	6.0%
t	2539	5.6%
l	2539	5.6%
i	2539	5.6%
a	1680	3.7%
Other values (16)	14197	31.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	45463	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	6108	13.4%
s	3398	7.5%
e	3387	7.5%
n	3187	7.0%
c	3150	6.9%
r	2739	6.0%
t	2539	5.6%
l	2539	5.6%
i	2539	5.6%
a	1680	3.7%
Other values (16)	14197	31.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	45463	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	6108	13.4%
s	3398	7.5%
e	3387	7.5%
n	3187	7.0%
c	3150	6.9%
r	2739	6.0%
t	2539	5.6%
l	2539	5.6%
i	2539	5.6%
a	1680	3.7%
Other values (16)	14197	31.2%

ProductSubCategory
Categorical

High correlation

Distinct	13
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	321.1 KiB

Headphones	1227
Academic	536
Shirt	501
Fiction	455
Educational	274
Other values (8)	2017

Length

Max length	15
Median length	11
Mean length	8.5968064
Min length	5

Characters and Unicode

Total characters	43070
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Camera
2nd row	Mobile
3rd row	Action Figures
4th row	Decor
5th row	Camera

Common Values

Value	Count	Frequency (%)
Headphones	1227	24.5%
Academic	536	10.7%
Shirt	501	10.0%
Fiction	455	9.1%
Educational	274	5.5%
Dolls	273	5.4%
Mobile	272	5.4%
Action Figures	258	5.1%
Gardening Tools	255	5.1%
Decor	246	4.9%
Other values (3)	713	14.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
headphones	1227	22.2%
academic	536	9.7%
shirt	501	9.1%
fiction	455	8.2%
educational	274	5.0%
dolls	273	4.9%
mobile	272	4.9%
action	258	4.7%
figures	258	4.7%
gardening	255	4.6%
Other values (5)	1214	22.0%

Most occurring characters

Value	Count	Frequency (%)
e	4503	10.5%
o	3977	9.2%
i	3963	9.2%
n	3423	7.9%
a	3056	7.1%
c	2536	5.9%
d	2292	5.3%
s	2013	4.7%
r	1979	4.6%
t	1956	4.5%
Other values (21)	13372	31.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	43070	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	4503	10.5%
o	3977	9.2%
i	3963	9.2%
n	3423	7.9%
a	3056	7.1%
c	2536	5.9%
d	2292	5.3%
s	2013	4.7%
r	1979	4.6%
t	1956	4.5%
Other values (21)	13372	31.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	43070	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	4503	10.5%
o	3977	9.2%
i	3963	9.2%
n	3423	7.9%
a	3056	7.1%
c	2536	5.9%
d	2292	5.3%
s	2013	4.7%
r	1979	4.6%
t	1956	4.5%
Other values (21)	13372	31.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	43070	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	4503	10.5%
o	3977	9.2%
i	3963	9.2%
n	3423	7.9%
a	3056	7.1%
c	2536	5.9%
d	2292	5.3%
s	2013	4.7%
r	1979	4.6%
t	1956	4.5%
Other values (21)	13372	31.0%

ProductPrice
Categorical

High correlation

Distinct	43
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	310.8 KiB

InvalidPrice	449
0.01	274
99999.99	252
46.23	196
693.39	196
Other values (38)	3643

Length

Max length	17
Median length	6
Mean length	6.498004
Min length	4

Characters and Unicode

Total characters	32555
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.01
2nd row	847.43
3rd row	386.57
4th row	364.01
5th row	652.35

Common Values

Value	Count	Frequency (%)
InvalidPrice	449	9.0%
0.01	274	5.5%
99999.99	252	5.0%
46.23	196	3.9%
693.39	196	3.9%
386.57	196	3.9%
461.09	192	3.8%
847.43	191	3.8%
268.61	186	3.7%
951.53	186	3.7%
Other values (33)	2692	53.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
invalidprice	449	9.0%
0.01	274	5.5%
99999.99	252	5.0%
46.23	196	3.9%
693.39	196	3.9%
386.57	196	3.9%
461.09	192	3.8%
847.43	191	3.8%
268.61	186	3.7%
951.53	186	3.7%
Other values (33)	2692	53.7%

Most occurring characters

Value	Count	Frequency (%)
.	4561	14.0%
9	3430	10.5%
1	3023	9.3%
3	2843	8.7%
6	2644	8.1%
0	2552	7.8%
8	2043	6.3%
4	1833	5.6%
2	1808	5.6%
5	1794	5.5%
Other values (12)	6024	18.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	32555	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	4561	14.0%
9	3430	10.5%
1	3023	9.3%
3	2843	8.7%
6	2644	8.1%
0	2552	7.8%
8	2043	6.3%
4	1833	5.6%
2	1808	5.6%
5	1794	5.5%
Other values (12)	6024	18.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	32555	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	4561	14.0%
9	3430	10.5%
1	3023	9.3%
3	2843	8.7%
6	2644	8.1%
0	2552	7.8%
8	2043	6.3%
4	1833	5.6%
2	1808	5.6%
5	1794	5.5%
Other values (12)	6024	18.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	32555	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	4561	14.0%
9	3430	10.5%
1	3023	9.3%
3	2843	8.7%
6	2644	8.1%
0	2552	7.8%
8	2043	6.3%
4	1833	5.6%
2	1808	5.6%
5	1794	5.5%
Other values (12)	6024	18.5%

CustomerName
Text

Distinct	4846
Distinct (%)	96.7%
Missing	0
Missing (%)	0.0%
Memory size	343.9 KiB

Length

Max length	28
Median length	24
Mean length	13.268862
Min length	7

Characters and Unicode

Total characters	66477
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4707 ?
Unique (%)	94.0%

Sample

1st row	Colleen Kelly
2nd row	Joel Wright
3rd row	Thomas Sawyer
4th row	Tyler Gardner
5th row	Meagan Peterson

Value	Count	Frequency (%)
smith	119	1.2%
michael	110	1.1%
johnson	84	0.8%
james	82	0.8%
thomas	80	0.8%
john	77	0.8%
jennifer	72	0.7%
christopher	72	0.7%
david	66	0.6%
williams	63	0.6%
Other values (1420)	9437	92.0%

Most occurring characters

Value	Count	Frequency (%)
e	6188	9.3%
a	6049	9.1%
	5252	7.9%
n	4930	7.4%
r	4791	7.2%
i	4078	6.1%
o	3582	5.4%
l	3388	5.1%
s	2982	4.5%
h	2271	3.4%
Other values (42)	22966	34.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	66477	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	6188	9.3%
a	6049	9.1%
	5252	7.9%
n	4930	7.4%
r	4791	7.2%
i	4078	6.1%
o	3582	5.4%
l	3388	5.1%
s	2982	4.5%
h	2271	3.4%
Other values (42)	22966	34.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	66477	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	6188	9.3%
a	6049	9.1%
	5252	7.9%
n	4930	7.4%
r	4791	7.2%
i	4078	6.1%
o	3582	5.4%
l	3388	5.1%
s	2982	4.5%
h	2271	3.4%
Other values (42)	22966	34.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	66477	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	6188	9.3%
a	6049	9.1%
	5252	7.9%
n	4930	7.4%
r	4791	7.2%
i	4078	6.1%
o	3582	5.4%
l	3388	5.1%
s	2982	4.5%
h	2271	3.4%
Other values (42)	22966	34.5%

CustomerEmail
Text

Missing

Distinct	4450
Distinct (%)	98.8%
Missing	507
Missing (%)	10.1%
Memory size	362.7 KiB

Length

Max length	32
Median length	28
Mean length	21.849656
Min length	15

Characters and Unicode

Total characters	98389
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4408 ?
Unique (%)	97.9%

Sample

1st row	maryhurst@example.org
2nd row	sandersvictoria@example.org
3rd row	ospence@example.net
4th row	christopherjohnson@example.com
5th row	epowell@example.net

Value	Count	Frequency (%)
garciashawn@example.com	11	0.2%
xjackson@example.net	3	0.1%
fwilliams@example.net	3	0.1%
taylorrobert@example.com	2	< 0.1%
ijones@example.com	2	< 0.1%
jenniferreed@example.com	2	< 0.1%
wrightjennifer@example.net	2	< 0.1%
rtaylor@example.org	2	< 0.1%
osmith@example.com	2	< 0.1%
rallen@example.org	2	< 0.1%
Other values (4440)	4472	99.3%

Most occurring characters

Value	Count	Frequency (%)
e	14830	15.1%
a	9158	9.3%
m	7680	7.8%
l	7142	7.3%
o	5624	5.7%
r	5230	5.3%
p	5088	5.2%
n	4925	5.0%
x	4610	4.7%
@	4503	4.6%
Other values (28)	29599	30.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	98389	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	14830	15.1%
a	9158	9.3%
m	7680	7.8%
l	7142	7.3%
o	5624	5.7%
r	5230	5.3%
p	5088	5.2%
n	4925	5.0%
x	4610	4.7%
@	4503	4.6%
Other values (28)	29599	30.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	98389	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	14830	15.1%
a	9158	9.3%
m	7680	7.8%
l	7142	7.3%
o	5624	5.7%
r	5230	5.3%
p	5088	5.2%
n	4925	5.0%
x	4610	4.7%
@	4503	4.6%
Other values (28)	29599	30.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	98389	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	14830	15.1%
a	9158	9.3%
m	7680	7.8%
l	7142	7.3%
o	5624	5.7%
r	5230	5.3%
p	5088	5.2%
n	4925	5.0%
x	4610	4.7%
@	4503	4.6%
Other values (28)	29599	30.1%

CustomerAddress
Text

Distinct	5000
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	497.2 KiB

Length

Max length	65
Median length	56
Mean length	44.60519
Min length	22

Characters and Unicode

Total characters	223472
Distinct characters	64
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4999 ?
Unique (%)	99.8%

Sample

1st row	354 Mcdowell Turnpike, Port Charles, CT 95318
2nd row	24740 Fox Villages, New Tracie, MA 53038
3rd row	769 Joe Trail, East Terri, CA 43813
4th row	27783 Olivia Centers, Williamsmouth, AL 09809
5th row	25357 Blackwell Locks, Andreabury, MH 27857

Value	Count	Frequency (%)
suite	1103	3.0%
apt	1096	3.0%
port	372	1.0%
box	364	1.0%
new	343	0.9%
south	343	0.9%
lake	326	0.9%
east	320	0.9%
north	304	0.8%
west	299	0.8%
Other values (13437)	32011	86.8%

Most occurring characters

Value	Count	Frequency (%)
	31871	14.3%
e	11462	5.1%
,	9667	4.3%
a	9275	4.2%
t	8835	4.0%
r	8212	3.7%
i	7308	3.3%
o	7256	3.2%
n	6972	3.1%
s	6018	2.7%
Other values (54)	116596	52.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	223472	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	31871	14.3%
e	11462	5.1%
,	9667	4.3%
a	9275	4.2%
t	8835	4.0%
r	8212	3.7%
i	7308	3.3%
o	7256	3.2%
n	6972	3.1%
s	6018	2.7%
Other values (54)	116596	52.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	223472	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	31871	14.3%
e	11462	5.1%
,	9667	4.3%
a	9275	4.2%
t	8835	4.0%
r	8212	3.7%
i	7308	3.3%
o	7256	3.2%
n	6972	3.1%
s	6018	2.7%
Other values (54)	116596	52.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	223472	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	31871	14.3%
e	11462	5.1%
,	9667	4.3%
a	9275	4.2%
t	8835	4.0%
r	8212	3.7%
i	7308	3.3%
o	7256	3.2%
n	6972	3.1%
s	6018	2.7%
Other values (54)	116596	52.2%

CustomerPhone
Text

Distinct	5000
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	358.5 KiB

Length

Max length	22
Median length	19
Mean length	16.238922
Min length	10

Characters and Unicode

Total characters	81357
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4999 ?
Unique (%)	99.8%

Sample

1st row	908.610.2711x8507
2nd row	+1-408-938-0389x952
3rd row	001-929-516-1919x39288
4th row	8907712983
5th row	9999921886

Value	Count	Frequency (%)
449)651-5198x65597	11	0.2%
001-652-348-4765x0079	1	< 0.1%
864-925-8941	1	< 0.1%
306.753.6693x620	1	< 0.1%
841)652-5216x95122	1	< 0.1%
645.998.8051x74261	1	< 0.1%
908.610.2711x8507	1	< 0.1%
1-408-938-0389x952	1	< 0.1%
598.250.4181	1	< 0.1%
972-968-0237x0312	1	< 0.1%
Other values (4990)	4990	99.6%

Most occurring characters

Value	Count	Frequency (%)
-	7808	9.6%
1	6805	8.4%
0	6803	8.4%
3	6575	8.1%
5	6566	8.1%
8	6559	8.1%
7	6536	8.0%
9	6514	8.0%
2	6446	7.9%
4	6426	7.9%
Other values (6)	14319	17.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	81357	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	7808	9.6%
1	6805	8.4%
0	6803	8.4%
3	6575	8.1%
5	6566	8.1%
8	6559	8.1%
7	6536	8.0%
9	6514	8.0%
2	6446	7.9%
4	6426	7.9%
Other values (6)	14319	17.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	81357	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	7808	9.6%
1	6805	8.4%
0	6803	8.4%
3	6575	8.1%
5	6566	8.1%
8	6559	8.1%
7	6536	8.0%
9	6514	8.0%
2	6446	7.9%
4	6426	7.9%
Other values (6)	14319	17.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	81357	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	7808	9.6%
1	6805	8.4%
0	6803	8.4%
3	6575	8.1%
5	6566	8.1%
8	6559	8.1%
7	6536	8.0%
9	6514	8.0%
2	6446	7.9%
4	6426	7.9%
Other values (6)	14319	17.6%

CustomerSegment
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	305.1 KiB

Gold	1692
Silver	1683
Bronze	1635

Length

Max length	6
Median length	6
Mean length	5.3245509
Min length	4

Characters and Unicode

Total characters	26676
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Silver
2nd row	Gold
3rd row	Gold
4th row	Gold
5th row	Gold

Common Values

Value	Count	Frequency (%)
Gold	1692	33.8%
Silver	1683	33.6%
Bronze	1635	32.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gold	1692	33.8%
silver	1683	33.6%
bronze	1635	32.6%

Most occurring characters

Value	Count	Frequency (%)
l	3375	12.7%
o	3327	12.5%
r	3318	12.4%
e	3318	12.4%
d	1692	6.3%
G	1692	6.3%
i	1683	6.3%
S	1683	6.3%
v	1683	6.3%
B	1635	6.1%
Other values (2)	3270	12.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	26676	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	3375	12.7%
o	3327	12.5%
r	3318	12.4%
e	3318	12.4%
d	1692	6.3%
G	1692	6.3%
i	1683	6.3%
S	1683	6.3%
v	1683	6.3%
B	1635	6.1%
Other values (2)	3270	12.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	26676	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	3375	12.7%
o	3327	12.5%
r	3318	12.4%
e	3318	12.4%
d	1692	6.3%
G	1692	6.3%
i	1683	6.3%
S	1683	6.3%
v	1683	6.3%
B	1635	6.1%
Other values (2)	3270	12.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	26676	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	3375	12.7%
o	3327	12.5%
r	3318	12.4%
e	3318	12.4%
d	1692	6.3%
G	1692	6.3%
i	1683	6.3%
S	1683	6.3%
v	1683	6.3%
B	1635	6.1%
Other values (2)	3270	12.3%

SupplierName
Categorical

High correlation

Distinct	20
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	364.8 KiB

Gilbert, Miller and Lee	277
Mathis, Olson and Ryan	272
Smith PLC	272
Ramirez, Hicks and Lara	267
Higgins and Sons	263
Other values (15)	3659

Length

Max length	28
Median length	26
Mean length	17.535928
Min length	9

Characters and Unicode

Total characters	87855
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Rodriguez, Winters and Perez
2nd row	Lawson-Wilkins
3rd row	Lee-Miller
4th row	Soto-Rivera
5th row	Rodriguez, Winters and Perez

Common Values

Value	Count	Frequency (%)
Gilbert, Miller and Lee	277	5.5%
Mathis, Olson and Ryan	272	5.4%
Smith PLC	272	5.4%
Ramirez, Hicks and Lara	267	5.3%
Higgins and Sons	263	5.2%
Rodriguez, Winters and Perez	263	5.2%
Campos-Murillo	262	5.2%
Lee-Miller	256	5.1%
White and Sons	255	5.1%
Roman-Chambers	254	5.1%
Other values (10)	2369	47.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	2560	20.2%
sons	518	4.1%
jackson	479	3.8%
lee	277	2.2%
miller	277	2.2%
gilbert	277	2.2%
mathis	272	2.1%
ryan	272	2.1%
olson	272	2.1%
plc	272	2.1%
Other values (29)	7189	56.8%

Most occurring characters

Value	Count	Frequency (%)
a	7812	8.9%
	7655	8.7%
n	7283	8.3%
i	5371	6.1%
e	5340	6.1%
l	5285	6.0%
r	5244	6.0%
o	4882	5.6%
d	3549	4.0%
s	3338	3.8%
Other values (29)	32096	36.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87855	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	7812	8.9%
	7655	8.7%
n	7283	8.3%
i	5371	6.1%
e	5340	6.1%
l	5285	6.0%
r	5244	6.0%
o	4882	5.6%
d	3549	4.0%
s	3338	3.8%
Other values (29)	32096	36.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87855	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	7812	8.9%
	7655	8.7%
n	7283	8.3%
i	5371	6.1%
e	5340	6.1%
l	5285	6.0%
r	5244	6.0%
o	4882	5.6%
d	3549	4.0%
s	3338	3.8%
Other values (29)	32096	36.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87855	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	7812	8.9%
	7655	8.7%
n	7283	8.3%
i	5371	6.1%
e	5340	6.1%
l	5285	6.0%
r	5244	6.0%
o	4882	5.6%
d	3549	4.0%
s	3338	3.8%
Other values (29)	32096	36.5%

SupplierLocation
Categorical

High correlation

Distinct	20
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	338.9 KiB

Lake Juanland	277
Herreraland	272
Lake Candiceton	272
Dustinmouth	267
West Johnbury	263
Other values (15)	3659

Length

Max length	16
Median length	14
Mean length	12.250898
Min length	8

Characters and Unicode

Total characters	61377
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Irwinhaven
2nd row	Calderonchester
3rd row	South Emilyview
4th row	West Denise
5th row	Irwinhaven

Common Values

Value	Count	Frequency (%)
Lake Juanland	277	5.5%
Herreraland	272	5.4%
Lake Candiceton	272	5.4%
Dustinmouth	267	5.3%
West Johnbury	263	5.2%
Irwinhaven	263	5.2%
Lawsontown	262	5.2%
South Emilyview	256	5.1%
West Scott	255	5.1%
Dennischester	254	5.1%
Other values (10)	2369	47.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
west	963	13.3%
lake	549	7.6%
south	492	6.8%
juanland	277	3.8%
candiceton	272	3.7%
herreraland	272	3.7%
dustinmouth	267	3.7%
johnbury	263	3.6%
irwinhaven	263	3.6%
lawsontown	262	3.6%
Other values (14)	3379	46.5%

Most occurring characters

Value	Count	Frequency (%)
e	7195	11.7%
n	5576	9.1%
t	5198	8.5%
a	4365	7.1%
r	4007	6.5%
o	3998	6.5%
i	3436	5.6%
s	3186	5.2%
h	2512	4.1%
	2249	3.7%
Other values (24)	19655	32.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	61377	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	7195	11.7%
n	5576	9.1%
t	5198	8.5%
a	4365	7.1%
r	4007	6.5%
o	3998	6.5%
i	3436	5.6%
s	3186	5.2%
h	2512	4.1%
	2249	3.7%
Other values (24)	19655	32.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	61377	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	7195	11.7%
n	5576	9.1%
t	5198	8.5%
a	4365	7.1%
r	4007	6.5%
o	3998	6.5%
i	3436	5.6%
s	3186	5.2%
h	2512	4.1%
	2249	3.7%
Other values (24)	19655	32.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	61377	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	7195	11.7%
n	5576	9.1%
t	5198	8.5%
a	4365	7.1%
r	4007	6.5%
o	3998	6.5%
i	3436	5.6%
s	3186	5.2%
h	2512	4.1%
	2249	3.7%
Other values (24)	19655	32.0%

SupplierContact
Categorical

High correlation Missing

Distinct	20
Distinct (%)	0.4%
Missing	484
Missing (%)	9.7%
Memory size	349.9 KiB

(906)306-1777x264	248
+1-619-677-8121x28226	247
230-568-4141	240
459-301-8580	240
822-222-4939	239
Other values (15)	3312

Length

Max length	21
Median length	18
Mean length	15.280822
Min length	10

Characters and Unicode

Total characters	69161
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	6538306661
2nd row	+1-588-750-7646
3rd row	805-650-6257x5876
4th row	6538306661
5th row	805-650-6257x5876

Common Values

Value	Count	Frequency (%)
(906)306-1777x264	248	5.0%
+1-619-677-8121x28226	247	4.9%
230-568-4141	240	4.8%
459-301-8580	240	4.8%
822-222-4939	239	4.8%
853-738-3918	238	4.8%
6538306661	236	4.7%
001-324-909-1637x2831	234	4.7%
+1-588-750-7646	232	4.6%
288-572-7043	231	4.6%
Other values (10)	2141	42.7%
(Missing)	484	9.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
906)306-1777x264	248	5.5%
1-619-677-8121x28226	247	5.5%
230-568-4141	240	5.3%
459-301-8580	240	5.3%
822-222-4939	239	5.3%
853-738-3918	238	5.3%
6538306661	236	5.2%
001-324-909-1637x2831	234	5.2%
1-588-750-7646	232	5.1%
288-572-7043	231	5.1%
Other values (10)	2141	47.3%

Most occurring characters

Value	Count	Frequency (%)
-	8354	12.1%
7	7779	11.2%
2	7039	10.2%
6	6548	9.5%
5	5741	8.3%
8	5650	8.2%
0	5392	7.8%
1	5292	7.7%
3	5248	7.6%
9	4387	6.3%
Other values (6)	7731	11.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	69161	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	8354	12.1%
7	7779	11.2%
2	7039	10.2%
6	6548	9.5%
5	5741	8.3%
8	5650	8.2%
0	5392	7.8%
1	5292	7.7%
3	5248	7.6%
9	4387	6.3%
Other values (6)	7731	11.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	69161	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	8354	12.1%
7	7779	11.2%
2	7039	10.2%
6	6548	9.5%
5	5741	8.3%
8	5650	8.2%
0	5392	7.8%
1	5292	7.7%
3	5248	7.6%
9	4387	6.3%
Other values (6)	7731	11.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	69161	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	8354	12.1%
7	7779	11.2%
2	7039	10.2%
6	6548	9.5%
5	5741	8.3%
8	5650	8.2%
0	5392	7.8%
1	5292	7.7%
3	5248	7.6%
9	4387	6.3%
Other values (6)	7731	11.2%

ShipperName
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	299.5 KiB

Group	861
and Sons	851
LLC	846
PLC	832
Ltd	814

Length

Max length	8
Median length	3
Mean length	4.193014
Min length	3

Characters and Unicode

Total characters	21007
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	and Sons
2nd row	PLC
3rd row	PLC
4th row	LLC
5th row	Ltd

Common Values

Value	Count	Frequency (%)
Group	861	17.2%
and Sons	851	17.0%
LLC	846	16.9%
PLC	832	16.6%
Ltd	814	16.2%
Inc	806	16.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
group	861	14.7%
and	851	14.5%
sons	851	14.5%
llc	846	14.4%
plc	832	14.2%
ltd	814	13.9%
inc	806	13.8%

Most occurring characters

Value	Count	Frequency (%)
L	3338	15.9%
n	2508	11.9%
o	1712	8.1%
C	1678	8.0%
d	1665	7.9%
G	861	4.1%
u	861	4.1%
p	861	4.1%
r	861	4.1%
	851	4.1%
Other values (7)	5811	27.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21007	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	3338	15.9%
n	2508	11.9%
o	1712	8.1%
C	1678	8.0%
d	1665	7.9%
G	861	4.1%
u	861	4.1%
p	861	4.1%
r	861	4.1%
	851	4.1%
Other values (7)	5811	27.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21007	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	3338	15.9%
n	2508	11.9%
o	1712	8.1%
C	1678	8.0%
d	1665	7.9%
G	861	4.1%
u	861	4.1%
p	861	4.1%
r	861	4.1%
	851	4.1%
Other values (7)	5811	27.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21007	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	3338	15.9%
n	2508	11.9%
o	1712	8.1%
C	1678	8.0%
d	1665	7.9%
G	861	4.1%
u	861	4.1%
p	861	4.1%
r	861	4.1%
	851	4.1%
Other values (7)	5811	27.7%

ShippingMethod
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	298.6 KiB

Air	1707
Ground	1693
Sea	1610

Length

Max length	6
Median length	3
Mean length	4.0137725
Min length	3

Characters and Unicode

Total characters	20109
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ground
2nd row	Air
3rd row	Sea
4th row	Air
5th row	Sea

Common Values

Value	Count	Frequency (%)
Air	1707	34.1%
Ground	1693	33.8%
Sea	1610	32.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
air	1707	34.1%
ground	1693	33.8%
sea	1610	32.1%

Most occurring characters

Value	Count	Frequency (%)
r	3400	16.9%
A	1707	8.5%
i	1707	8.5%
G	1693	8.4%
o	1693	8.4%
u	1693	8.4%
n	1693	8.4%
d	1693	8.4%
S	1610	8.0%
e	1610	8.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20109	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	3400	16.9%
A	1707	8.5%
i	1707	8.5%
G	1693	8.4%
o	1693	8.4%
u	1693	8.4%
n	1693	8.4%
d	1693	8.4%
S	1610	8.0%
e	1610	8.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20109	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	3400	16.9%
A	1707	8.5%
i	1707	8.5%
G	1693	8.4%
o	1693	8.4%
u	1693	8.4%
n	1693	8.4%
d	1693	8.4%
S	1610	8.0%
e	1610	8.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20109	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	3400	16.9%
A	1707	8.5%
i	1707	8.5%
G	1693	8.4%
o	1693	8.4%
u	1693	8.4%
n	1693	8.4%
d	1693	8.4%
S	1610	8.0%
e	1610	8.0%

QuantitySold
Real number (ℝ)

High correlation

Distinct	100
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.827146

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.3 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	26
median	50
Q3	76
95-th percentile	95
Maximum	100
Range	99
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	28.523303
Coefficient of variation (CV)	0.56118247
Kurtosis	-1.1823428
Mean	50.827146
Median Absolute Deviation (MAD)	24
Skewness	0.00030494085
Sum	254644
Variance	813.57882
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45	70	1.4%
39	66	1.3%
80	65	1.3%
87	64	1.3%
73	63	1.3%
26	62	1.2%
92	60	1.2%
40	60	1.2%
30	59	1.2%
16	59	1.2%
Other values (90)	4382	87.5%

Value	Count	Frequency (%)
1	46	0.9%
2	44	0.9%
3	51	1.0%
4	41	0.8%
5	41	0.8%
6	47	0.9%
7	41	0.8%
8	39	0.8%
9	52	1.0%
10	48	1.0%

Value	Count	Frequency (%)
100	47	0.9%
99	57	1.1%
98	42	0.8%
97	46	0.9%
96	50	1.0%
95	48	1.0%
94	52	1.0%
93	52	1.0%
92	60	1.2%
91	47	0.9%

TotalAmount
Real number (ℝ)

High correlation

Distinct	1848
Distinct (%)	36.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28851.53

Minimum	46.23
Maximum	99513
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.3 KiB

Quantile statistics

Minimum	46.23
5-th percentile	1546.28
Q1	8864.13
median	23546.135
Q3	42985.95
95-th percentile	75624.129
Maximum	99513
Range	99466.77
Interquartile range (IQR)	34121.82

Descriptive statistics

Standard deviation	23139.578
Coefficient of variation (CV)	0.80202258
Kurtosis	-0.20417134
Mean	28851.53
Median Absolute Deviation (MAD)	16452.715
Skewness	0.78550937
Sum	1.4454616 × 10⁸
Variance	5.3544008 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33631.59	12	0.2%
48761.37	9	0.2%
76122.4	9	0.2%
64590.9	9	0.2%
31522.86	9	0.2%
77963.56	8	0.2%
44359.8	8	0.2%
17472.48	8	0.2%
3491.93	8	0.2%
39653.74	7	0.1%
Other values (1838)	4923	98.3%

Value	Count	Frequency (%)
46.23	1	< 0.1%
68.01	1	< 0.1%
92.46	1	< 0.1%
138.69	4	0.1%
184.92	3	0.1%
204.03	2	< 0.1%
228.82	2	< 0.1%
231.15	1	< 0.1%
268.61	4	0.1%
272.04	2	< 0.1%

Value	Count	Frequency (%)
99513	2	< 0.1%
98517.87	2	< 0.1%
97522.74	2	< 0.1%
96527.61	2	< 0.1%
95532.48	2	< 0.1%
95153	6	0.1%
94537.35	1	< 0.1%
94201.47	3	0.1%
93542.22	2	< 0.1%
93249.94	3	0.1%

DiscountAmount
Real number (ℝ)

Distinct	4353
Distinct (%)	86.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	86.425236

Minimum	0.01
Maximum	298.11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.3 KiB

Quantile statistics

Minimum	0.01
5-th percentile	4.538
Q1	25.685
median	69.345
Q3	129.2775
95-th percentile	228.5685
Maximum	298.11
Range	298.1
Interquartile range (IQR)	103.5925

Descriptive statistics

Standard deviation	70.574899
Coefficient of variation (CV)	0.8166006
Kurtosis	-0.26615701
Mean	86.425236
Median Absolute Deviation (MAD)	49.605
Skewness	0.79048336
Sum	432990.43
Variance	4980.8163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
88.77	11	0.2%
7.18	4	0.1%
17.79	4	0.1%
2.83	4	0.1%
96.71	4	0.1%
11.5	4	0.1%
88.78	4	0.1%
7.62	4	0.1%
8.21	3	0.1%
12.37	3	0.1%
Other values (4343)	4965	99.1%

Value	Count	Frequency (%)
0.01	1	< 0.1%
0.05	1	< 0.1%
0.06	1	< 0.1%
0.07	1	< 0.1%
0.09	1	< 0.1%
0.13	2	< 0.1%
0.14	2	< 0.1%
0.15	1	< 0.1%
0.17	1	< 0.1%
0.18	1	< 0.1%

Value	Count	Frequency (%)
298.11	1	< 0.1%
296.11	1	< 0.1%
295.18	1	< 0.1%
295.08	1	< 0.1%
293.84	1	< 0.1%
293.28	1	< 0.1%
291.22	1	< 0.1%
290.07	1	< 0.1%
289.26	1	< 0.1%
289.11	1	< 0.1%

NetAmount
Real number (ℝ)

High correlation

Distinct	4999
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28765.104

Minimum	33.6
Maximum	99276.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.3 KiB

Quantile statistics

Minimum	33.6
5-th percentile	1497.0885
Q1	8774.435
median	23424.75
Q3	42886.6
95-th percentile	75463.623
Maximum	99276.95
Range	99243.35
Interquartile range (IQR)	34112.165

Descriptive statistics

Standard deviation	23112.636
Coefficient of variation (CV)	0.80349563
Kurtosis	-0.20322873
Mean	28765.104
Median Absolute Deviation (MAD)	16388.65
Skewness	0.78626283
Sum	1.4411317 × 10⁸
Variance	5.3419393 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33542.82	11	0.2%
33682.91	2	< 0.1%
48789.08	1	< 0.1%
53284.87	1	< 0.1%
25637.75	1	< 0.1%
2172.89	1	< 0.1%
22715.3	1	< 0.1%
39019.81	1	< 0.1%
6238.81	1	< 0.1%
19967.29	1	< 0.1%
Other values (4989)	4989	99.6%

Value	Count	Frequency (%)
33.6	1	< 0.1%
57.81	1	< 0.1%
83.22	1	< 0.1%
125.11	1	< 0.1%
126.83	1	< 0.1%
128.04	1	< 0.1%
129.8	1	< 0.1%
175.81	1	< 0.1%
178.04	1	< 0.1%
183.97	1	< 0.1%

Value	Count	Frequency (%)
99276.95	1	< 0.1%
99246.13	1	< 0.1%
98471.73	1	< 0.1%
98299.72	1	< 0.1%
97494.61	1	< 0.1%
97409.48	1	< 0.1%
96325.22	1	< 0.1%
96267.15	1	< 0.1%
95421.03	1	< 0.1%
95260.03	1	< 0.1%

StockReceived
Real number (ℝ)

High correlation

Distinct	451
Distinct (%)	9.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	277.07405

Minimum	50
Maximum	500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.3 KiB

Quantile statistics

Minimum	50
5-th percentile	72
Q1	164
median	279
Q3	393
95-th percentile	478
Maximum	500
Range	450
Interquartile range (IQR)	229

Descriptive statistics

Standard deviation	130.3307
Coefficient of variation (CV)	0.47038218
Kurtosis	-1.2123356
Mean	277.07405
Median Absolute Deviation (MAD)	115
Skewness	-0.029436097
Sum	1388141
Variance	16986.091
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
347	23	0.5%
290	23	0.5%
401	22	0.4%
258	21	0.4%
143	21	0.4%
341	21	0.4%
185	21	0.4%
464	21	0.4%
430	20	0.4%
281	20	0.4%
Other values (441)	4797	95.7%

Value	Count	Frequency (%)
50	11	0.2%
51	14	0.3%
52	6	0.1%
53	14	0.3%
54	6	0.1%
55	11	0.2%
56	4	0.1%
57	13	0.3%
58	10	0.2%
59	8	0.2%

Value	Count	Frequency (%)
500	20	0.4%
499	12	0.2%
498	5	0.1%
497	7	0.1%
496	19	0.4%
495	6	0.1%
494	9	0.2%
493	9	0.2%
492	14	0.3%
491	13	0.3%

StockSold
Real number (ℝ)

High correlation

Distinct	461
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	139.11697

Minimum	1
Maximum	498
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.3 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	49
median	109
Q3	209
95-th percentile	362
Maximum	498
Range	497
Interquartile range (IQR)	160

Descriptive statistics

Standard deviation	111.01637
Coefficient of variation (CV)	0.79800741
Kurtosis	-0.067428197
Mean	139.11697
Median Absolute Deviation (MAD)	71
Skewness	0.87581816
Sum	696976
Variance	12324.634
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39	34	0.7%
7	34	0.7%
56	34	0.7%
12	33	0.7%
64	33	0.7%
38	33	0.7%
60	32	0.6%
27	32	0.6%
49	32	0.6%
50	31	0.6%
Other values (451)	4682	93.5%

Value	Count	Frequency (%)
1	24	0.5%
2	22	0.4%
3	24	0.5%
4	22	0.4%
5	27	0.5%
6	25	0.5%
7	34	0.7%
8	24	0.5%
9	26	0.5%
10	24	0.5%

Value	Count	Frequency (%)
498	1	< 0.1%
494	2	< 0.1%
493	1	< 0.1%
486	1	< 0.1%
485	2	< 0.1%
483	1	< 0.1%
482	1	< 0.1%
477	1	< 0.1%
473	2	< 0.1%
469	1	< 0.1%

StockOnHand
Real number (ℝ)

High correlation

Distinct	464
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	137.95709

Minimum	0
Maximum	490
Zeros	31
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	39.3 KiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	49
median	107
Q3	206
95-th percentile	359.55
Maximum	490
Range	490
Interquartile range (IQR)	157

Descriptive statistics

Standard deviation	110.36069
Coefficient of variation (CV)	0.79996393
Kurtosis	-0.018666969
Mean	137.95709
Median Absolute Deviation (MAD)	70
Skewness	0.88968298
Sum	691165
Variance	12179.482
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	38	0.8%
50	37	0.7%
42	36	0.7%
10	35	0.7%
15	34	0.7%
34	34	0.7%
31	32	0.6%
0	31	0.6%
19	31	0.6%
38	31	0.6%
Other values (454)	4671	93.2%

Value	Count	Frequency (%)
0	31	0.6%
1	26	0.5%
2	29	0.6%
3	20	0.4%
4	26	0.5%
5	22	0.4%
6	25	0.5%
7	22	0.4%
8	24	0.5%
9	28	0.6%

Value	Count	Frequency (%)
490	1	< 0.1%
488	1	< 0.1%
484	1	< 0.1%
482	2	< 0.1%
481	2	< 0.1%
476	1	< 0.1%
474	1	< 0.1%
473	2	< 0.1%
470	1	< 0.1%
469	1	< 0.1%

	CustomerSegment	DiscountAmount	NetAmount	ProductCategory	ProductName	ProductPrice	ProductSubCategory	QuantitySold	ShipperName	ShippingMethod	StockOnHand	StockReceived	StockSold	SupplierContact	SupplierLocation	SupplierName	TotalAmount
CustomerSegment	1.000	0.016	0.032	0.014	0.024	0.053	0.036	0.000	0.019	0.000	0.000	0.000	0.021	0.036	0.031	0.031	0.033
DiscountAmount	0.016	1.000	0.413	0.228	0.280	0.264	0.251	-0.008	0.000	0.019	-0.004	0.007	0.013	0.017	0.007	0.007	0.417
NetAmount	0.032	0.413	1.000	0.222	0.279	0.263	0.250	0.696	0.000	0.039	-0.008	0.007	0.015	0.000	0.000	0.000	1.000
ProductCategory	0.014	0.228	0.222	1.000	0.805	0.752	0.845	0.023	0.000	0.000	0.000	0.000	0.000	0.019	0.000	0.000	0.221
ProductName	0.024	0.280	0.279	0.805	1.000	0.828	0.952	0.021	0.000	0.034	0.010	0.000	0.016	0.011	0.001	0.001	0.279
ProductPrice	0.053	0.264	0.263	0.752	0.828	1.000	0.893	0.000	0.000	0.005	0.000	0.000	0.000	0.007	0.000	0.000	0.262
ProductSubCategory	0.036	0.251	0.250	0.845	0.952	0.893	1.000	0.013	0.000	0.010	0.000	0.000	0.019	0.010	0.000	0.000	0.250
QuantitySold	0.000	-0.008	0.696	0.023	0.021	0.000	0.013	1.000	0.000	0.028	-0.013	-0.001	0.002	0.000	0.000	0.000	0.694
ShipperName	0.019	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.010	0.000	0.000	0.041	0.039	0.039	0.000
ShippingMethod	0.000	0.019	0.039	0.000	0.034	0.005	0.010	0.028	0.000	1.000	0.000	0.024	0.000	0.000	0.000	0.000	0.037
StockOnHand	0.000	-0.004	-0.008	0.000	0.010	0.000	0.000	-0.013	0.010	0.000	1.000	0.561	-0.255	0.013	0.002	0.002	-0.008
StockReceived	0.000	0.007	0.007	0.000	0.000	0.000	0.000	-0.001	0.000	0.024	0.561	1.000	0.572	0.000	0.000	0.000	0.007
StockSold	0.021	0.013	0.015	0.000	0.016	0.000	0.019	0.002	0.000	0.000	-0.255	0.572	1.000	0.000	0.000	0.000	0.015
SupplierContact	0.036	0.017	0.000	0.019	0.011	0.007	0.010	0.000	0.041	0.000	0.013	0.000	0.000	1.000	1.000	1.000	0.000
SupplierLocation	0.031	0.007	0.000	0.000	0.001	0.000	0.000	0.000	0.039	0.000	0.002	0.000	0.000	1.000	1.000	1.000	0.000
SupplierName	0.031	0.007	0.000	0.000	0.001	0.000	0.000	0.000	0.039	0.000	0.002	0.000	0.000	1.000	1.000	1.000	0.000
TotalAmount	0.033	0.417	1.000	0.221	0.279	0.262	0.250	0.694	0.000	0.037	-0.008	0.007	0.015	0.000	0.000	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Date	ProductName	ProductCategory	ProductSubCategory	ProductPrice	CustomerName	CustomerEmail	CustomerAddress	CustomerPhone	CustomerSegment	SupplierName	SupplierLocation	SupplierContact	ShipperName	ShippingMethod	QuantitySold	TotalAmount	DiscountAmount	NetAmount	StockReceived	StockSold	StockOnHand
0	2023-09-14	Nathaniel	Electronics	Camera	0.01	Colleen Kelly	maryhurst@example.org	354 Mcdowell Turnpike, Port Charles, CT 95318	908.610.2711x8507	Silver	Rodriguez, Winters and Perez	Irwinhaven	6538306661	and Sons	Ground	49	31965.15	121.07	31844.08	475	127	348
1	2023-02-11	NonExistentProduct	Electronics	Mobile	847.43	Joel Wright	sandersvictoria@example.org	24740 Fox Villages, New Tracie, MA 53038	+1-408-938-0389x952	Gold	Lawson-Wilkins	Calderonchester	NaN	PLC	Air	73	61862.39	91.09	61771.30	487	243	244
2	2021-11-12	Angela	InvalidCategory	Action Figures	386.57	Thomas Sawyer	ospence@example.net	769 Joe Trail, East Terri, CA 43813	001-929-516-1919x39288	Gold	Lee-Miller	South Emilyview	+1-588-750-7646	PLC	Sea	89	34404.73	10.56	34394.17	341	188	153
3	11-15-2021	Amy	Home & Garden	Decor	364.01	Tyler Gardner	christopherjohnson@example.com	27783 Olivia Centers, Williamsmouth, AL 09809	8907712983	Gold	Soto-Rivera	West Denise	805-650-6257x5876	LLC	Air	3	1092.03	69.06	1022.97	500	124	376
4	2023-04-22	Nathaniel	Electronics	Camera	652.35	Meagan Peterson	epowell@example.net	25357 Blackwell Locks, Andreabury, MH 27857	9999921886	Gold	Rodriguez, Winters and Perez	Irwinhaven	6538306661	Ltd	Sea	75	48926.25	137.17	48789.08	429	351	78
5	2022-12-08	NonExistentProduct	Electronics	Mobile	847.43	Justin Hodge	NaN	PSC 1552, Box 7906, APO AP 50694	001-691-442-5371x97648	Gold	Soto-Rivera	West Denise	805-650-6257x5876	Inc	Ground	63	53388.09	103.22	53284.87	79	61	18
6	2023-09-13	Justin	Electronics	Headphones	66005.0	Kelly Williams	philip97@example.com	5881 Shawn Fords Apt. 256, Martinezbury, NH 01010	001-275-372-4620	Silver	Soto-Rivera	West Denise	805-650-6257x5876	and Sons	Ground	39	25741.95	104.20	25637.75	339	296	43
7	2023-07-19	NonExistentProduct	Electronics	Camera	652.35	Natasha Thomas	rcole@example.org	040 Lopez Crossing Apt. 758, Victormouth, RI 51198	998-812-6450x26711	Silver	Campos-Murillo	Lawsontown	822-222-4939	Group	Ground	60	39141.00	121.19	39019.81	305	53	252
8	2023-08-20	Shannon	Home & Garden	Gardening Tools	68.01	Jessica Sanchez	NaN	455 Mary Path, Cobbberg, PW 26662	972-968-0237x0312	Gold	Wagner, Jackson and Holt	Port Sarahview	+1-362-752-2777x1817	Inc	Air	92	6256.92	18.11	6238.81	440	338	102
9	2023-07-15	NonExistentProduct	Home & Garden	Decor	364.01	Nathan Good	NaN	27534 Jennifer Burgs Suite 449, West Lauraville, AK 18548	322.403.9678x196	Gold	White and Sons	West Scott	288-572-7043	PLC	Air	55	20020.55	53.26	19967.29	260	254	6

	Date	ProductName	ProductCategory	ProductSubCategory	ProductPrice	CustomerName	CustomerEmail	CustomerAddress	CustomerPhone	CustomerSegment	SupplierName	SupplierLocation	SupplierContact	ShipperName	ShippingMethod	QuantitySold	TotalAmount	DiscountAmount	NetAmount	StockReceived	StockSold	StockOnHand
5000	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5001	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5002	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5003	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5004	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5005	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5006	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5007	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5008	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42
5009	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42

Most frequently occurring

	Date	ProductName	ProductCategory	ProductSubCategory	ProductPrice	CustomerName	CustomerEmail	CustomerAddress	CustomerPhone	CustomerSegment	SupplierName	SupplierLocation	SupplierContact	ShipperName	ShippingMethod	QuantitySold	TotalAmount	DiscountAmount	NetAmount	StockReceived	StockSold	StockOnHand	# duplicates
0	2023-08-24	Angela	Toys	Action Figures	386.57	Bradley Smith	garciashawn@example.com	Unit 6079 Box 2184, DPO AP 21061	(449)651-5198x65597	Gold	Roman-Chambers	Dennischester	001-324-909-1637x2831	LLC	Ground	87	33631.59	88.77	33542.82	401	359	42	11

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block